
<%@page import="model.Ligne"%>
<%@page import="web.Operation"%>
<%@page import="web.UhtBeans"%>
<%@page import="java.util.ArrayList"%>

<%@page import="java.util.Iterator"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    
    
    <script type="text/javascript">
var tableToExcel = (function() {
  var uri = 'data:application/vnd.ms-excel;base64,'
    , template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook></xml><![endif]--></head><body><table>{table}</table></body></html>'
    , base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }
    , format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }
  return function(table, name) {
    if (!table.nodeType) table = document.getElementById(table)
    var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}
    window.location.href = uri + base64(format(template, ctx))
  }
})()
</script>

<div id="export" ><input type="button" onclick="tableToExcel('testTable2', 'W3C Example Table')" value="     Export to Excel   ">
</div>
<p></p>
<table id="testTable2" border="1" width=100% class="table table-hover"><thead>
			<tr>
				<th>Id Ligne</th>
				<th>Nom Ligne</th>						
			
				
			</tr>
			</thead>
			<tbody id="colonne">
			
<%
UhtBeans lignes;
if(request.getAttribute("ligne") != null){
	
	lignes =(UhtBeans) request.getAttribute("ligne");
	
}else {
	Operation oper = new Operation();
	lignes = new UhtBeans();
	lignes.setListeLi(oper.allLigne());
}

%>
			<%
		
			Iterator<Ligne> list = lignes.getListeLi().iterator();
		        while(list.hasNext()){
		        	Ligne li =list.next();
		        	 
				        	
			%>
			
			<tr >
				<th class="IdLi"><%=li.getIdligne() %></th>
				<th class="NomLi"><%=li.getNomligne() %></th>
				<th class="isSent" style="display: none;" ></th>
				
				
				
			</tr>

				<%
		        }
				%>

			
			</tbody>


		</table>
		
		
		
		


